Welcome to the next section during this section we're going to talk about how to streamline your efforts
and become more efficient as you're working with large sets of data within Excel.
We've talked about all sorts of tools that we haven't set of Excel as we work with lists these like
sorting filtering pivot tables calculations and so on.
Now I want to introduce you to some features that are going to make your life easier or even easier
as you work with these other tools that we've already discussed.
So the first one this is called freeze panes.
Now we've actually seen this but very indirectly just kind of happened as a result of another feature
.
And I didn't really talk about it but now I want to show off this freeze panes feature and how it's
going to help you maintain larger lists.
So take a look up in front of you.
I've got our example file Excel one or two exercises and I'm currently on the employee records worksheet
.
Now we've got our list here.
It's got some column headers up at the top.
We talked about how important those columns that headers are because they help you and your co-workers
access this list right.
They identify what goes into the list.
But here's the problem.
The column headers show up at the top of the list which means if I scroll down to get to the bottom
of the list or to get to a specific record I lose those column headers.
They go right off the top of the screen oops.
Now what do I do.
Why I'm down here entering a record right.
And I get to call D and it's like wait a minute what columns that we should be putting in here.
Like I scroll back to the top of its department.
I scroll back down.
Start entering my data.
I get to here and say oh what's these numbers.
I had to scroll back to the top oh it's font extension.
Right.
A lot of this back and forth right.
Trying to determine what should I be putting in these columns well to fix this problem.
We're going to freeze the column headers in place that way as you scroll up and now they stay put.
Take a look.
This is super easy.
So all I'm going to do is click in the column a row too.
So I'm inside a cell A-2.
And the reason why I click there is now when I go to freeze the panes it will freeze everything up above
the current cell I have selected.
Simon ETU my headers are right above it.
I'm now going to go up to my view tab top my screen view and side of view I have a section called window
and inside a window.
I'm going to go to freeze panes and I'm going to freeze the panes.
So now if I scroll up and down those headers stay put.
Look at that row one is always there frozen and Spot.
Very nice right.
I don't put my finger on the screen anymore and scroll up and then try to remember what column I meant
.
They're always there no matter how much I scroll up and down for it frees the panes I've now freezed
or frozen the first row of the headers at the top of my.
And really simple quick in the 8 to go up to view.
Freeze panes freeze the page.
If you decide you're tired of it you don't need it anymore.
You can always reverse it.
You can on freeze the pains as well.
So try this out.
Jump in to the exercise file.
Go to and play records and freeze the headers so that when you scroll up and now they're always there